package com.mr.sell.mapper;

import com.mr.sell.entity.ProductInfo;
import org.apache.ibatis.annotations.Insert;

public interface ProductInfoMapper{

        @Insert("insert into product_info (" +
                "  product_id, " +
                "  product_name, " +
                "  product_price, " +
                "  product_stock, " +
                "  product_description, " +
                "  product_icon, " +
                "  product_status, " +
                "  category_type) " +
                "  values( " +
                "  #{productId,jdbcType=INTEGER}," +
                "  #{productName,jdbcType=VARCHAR}," +
                "  #{productPrice,jdbcType=DECIMAL}," +
                "  #{productStock,jdbcType=INTEGER}," +
                "  #{productDescription,jdbcType=VARCHAR}," +
                "  #{productIcon,jdbcType=VARCHAR}," +
                "  #{productStatus,jdbcType=INTEGER}," +
                "  #{categoryType,jdbcType=INTEGER}" +
                "  )" )
        int saveProductInfo(ProductInfo info);
}
